﻿<%@ Page Language="C#" MasterPageFile="~/Admin/MasterPage.master" AutoEventWireup="true" CodeFile="ViewHFCustomerAppDetail.aspx.cs" Inherits="Admin_home_refinance_ViewHFCustomerAppDetail" Title="Home Loan - Application Detail" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<div class="contentsfull">
    <table width="100%" cellpadding="3" cellspacing="0" border="0">
        <tr>
            <td>
                <h1>Customer Personnel Detail</h1>
            </td>
        </tr>
        <tr>
            <td>
                <asp:DetailsView ID="dvPersonnelDetail" runat="server" AutoGenerateRows="False" 
                    CellPadding="3" DataKeyNames="HFPersonnelID,HFJBPersonnelID" 
                    DataSourceID="sqlDsCustomerAppDetails" ForeColor="#333333" GridLines="None" 
                    CellSpacing="1" Width="100%" EmptyDataText="No data." BorderStyle="Solid" BorderColor="#eff7fa" BorderWidth="1px">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
                    <RowStyle BackColor="#fbfeff" ForeColor="#333333" />
                    <FieldHeaderStyle BackColor="#eff7fa" Font-Bold="True" Width="200px" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <Fields>
                        <asp:BoundField DataField="HFPersonnelID" HeaderText="HFPersonnelID" 
                            InsertVisible="False" ReadOnly="True" SortExpression="HFPersonnelID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFID" HeaderText="HFID" SortExpression="HFID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFSalutation" HeaderText="HFSalutation" 
                            SortExpression="HFSalutation" />
                        <asp:BoundField DataField="HFFirstName" HeaderText="HFFirstName" 
                            SortExpression="HFFirstName" />
                        <asp:BoundField DataField="HFSurname" HeaderText="HFSurname" 
                            SortExpression="HFSurname" />
                        <asp:BoundField DataField="HFNationality" HeaderText="HFNationality" 
                            SortExpression="HFNationality" />
                        <asp:BoundField DataField="HFDOB" HeaderText="HFDOB" SortExpression="HFDOB" />
                        <asp:BoundField DataField="HFIdType" HeaderText="HFIdType" 
                            SortExpression="HFIdType" />
                        <asp:BoundField DataField="HFIdNo" HeaderText="HFIdNo" 
                            SortExpression="HFIdNo" />
                        <asp:BoundField DataField="HFIdIssDate" HeaderText="HFIdIssDate" 
                            SortExpression="HFIdIssDate" />
                        <asp:BoundField DataField="HFIdExpDate" HeaderText="HFIdExpDate" 
                            SortExpression="HFIdExpDate" />
                        <asp:BoundField DataField="HFIdIssCountry" HeaderText="HFIdIssCountry" 
                            SortExpression="HFIdIssCountry" />
                        <asp:BoundField DataField="HFGender" HeaderText="HFGender" 
                            SortExpression="HFGender" />
                        <asp:BoundField DataField="HFMaritalStatus" HeaderText="HFMaritalStatus" 
                            SortExpression="HFMaritalStatus" />
                        <asp:BoundField DataField="HFNoOfDependents" HeaderText="HFNoOfDependents" 
                            SortExpression="HFNoOfDependents" />
                        <asp:BoundField DataField="HFHighestEdu" HeaderText="HFHighestEdu" 
                            SortExpression="HFHighestEdu" />
                        <asp:CheckBoxField DataField="HFIsMainBorrower" HeaderText="HFIsMainBorrower" 
                            SortExpression="HFIsMainBorrower" />
                        <asp:BoundField DataField="HFJBPersonnelID" HeaderText="HFJBPersonnelID" 
                            SortExpression="HFJBPersonnelID" />
                        <asp:CheckBoxField DataField="Status" HeaderText="Status" 
                            SortExpression="Status" Visible="False" />
                        <asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" 
                            SortExpression="CreatedDate" Visible="False" />
                        <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" 
                            SortExpression="ModifiedDate" Visible="False" />
                    </Fields>
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#999999" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                </asp:DetailsView>
                <asp:SqlDataSource ID="sqlDsCustomerAppDetails" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>" 
                    SelectCommand="sprocHFPersonnelSelectSingleItemView" 
                    SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="HFID" QueryStringField="HFID" Type="Int64" />
                        <asp:QueryStringParameter DefaultValue="" Name="IsMain" 
                            QueryStringField="IsMain" Type="Int16" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td>
                <h1>Contact Details</h1>
            </td>
         </tr>
        <tr>
            <td>
                <asp:DetailsView ID="dvContact" runat="server" AutoGenerateRows="False" 
                    CellPadding="3" DataKeyNames="HFContactID" DataSourceID="sqlDsContact" 
                    ForeColor="#333333" GridLines="None" CellSpacing="1" Width="100%" 
                    EmptyDataText="No data." BorderStyle="Solid" BorderColor="#eff7fa" BorderWidth="1px">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
                    <RowStyle BackColor="#fbfeff" ForeColor="#333333" />
                    <FieldHeaderStyle BackColor="#eff7fa" Font-Bold="True" Width="200px" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <Fields>
                        <asp:BoundField DataField="HFContactID" HeaderText="HFContactID" 
                            InsertVisible="False" ReadOnly="True" SortExpression="HFContactID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFPersonnelID" HeaderText="HFPersonnelID" 
                            SortExpression="HFPersonnelID" Visible="False" />
                        <asp:BoundField DataField="HFEmail" HeaderText="HFEmail" 
                            SortExpression="HFEmail" />
                        <asp:BoundField DataField="HFMobilePhoneNo" HeaderText="HFMobilePhoneNo" 
                            SortExpression="HFMobilePhoneNo" />
                        <asp:BoundField DataField="HFOfficePhoneNo" HeaderText="HFOfficePhoneNo" 
                            SortExpression="HFOfficePhoneNo" />
                        <asp:BoundField DataField="HFHomePhoneNo" HeaderText="HFHomePhoneNo" 
                            SortExpression="HFHomePhoneNo" />
                        <asp:BoundField DataField="HFPostCode" HeaderText="HFPostCode" 
                            SortExpression="HFPostCode" />
                        <asp:BoundField DataField="HFBHNo" HeaderText="HFBHNo" 
                            SortExpression="HFBHNo" />
                        <asp:BoundField DataField="HFHomeNo" HeaderText="HFHomeNo" 
                            SortExpression="HFHomeNo" />
                        <asp:BoundField DataField="HFStreetName" HeaderText="HFStreetName" 
                            SortExpression="HFStreetName" />
                        <asp:BoundField DataField="HFYearsThere" HeaderText="HFYearsThere" 
                            SortExpression="HFYearsThere" />
                        <asp:BoundField DataField="HFMailPostCode" HeaderText="HFMailPostCode" 
                            SortExpression="HFMailPostCode" />
                        <asp:BoundField DataField="HFMailBHNo" HeaderText="HFMailBHNo" 
                            SortExpression="HFMailBHNo" />
                        <asp:BoundField DataField="HFMailHomeNo" HeaderText="HFMailHomeNo" 
                            SortExpression="HFMailHomeNo" />
                        <asp:BoundField DataField="HFMailStreetName" HeaderText="HFMailStreetName" 
                            SortExpression="HFMailStreetName" />
                        <asp:BoundField DataField="HFEmContact" HeaderText="HFEmContact" 
                            SortExpression="HFEmContact" />
                        <asp:BoundField DataField="HFEmContactNo" HeaderText="HFEmContactNo" 
                            SortExpression="HFEmContactNo" />
                        <asp:BoundField DataField="HFEmRelationship" HeaderText="HFEmRelationship" 
                            SortExpression="HFEmRelationship" />
                        <asp:CheckBoxField DataField="HFIsMainBorrower" HeaderText="HFIsMainBorrower" 
                            SortExpression="HFIsMainBorrower" />
                        <asp:CheckBoxField DataField="Status" HeaderText="Status" 
                            SortExpression="Status" Visible="False" />
                        <asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" 
                            SortExpression="CreatedDate" Visible="False" />
                        <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" 
                            SortExpression="ModifiedDate" Visible="False" />
                    </Fields>
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#999999" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                </asp:DetailsView>
                <asp:SqlDataSource ID="sqlDsContact" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>" 
                    SelectCommand="sprocHFContactSelectSingleItemView" 
                    SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="HFID" QueryStringField="HFID" Type="Int64" />
                        <asp:QueryStringParameter DefaultValue="" Name="IsMain" 
                            QueryStringField="IsMain" Type="Int16" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td>
                <h1>Employment Deatail</h1>
            </td>
        </tr>
        <tr>
            <td>
                <asp:DetailsView ID="dvEmployment" runat="server" AutoGenerateRows="False" 
                    CellPadding="3" DataKeyNames="HFEmpID" DataSourceID="sqlDsEmploymentDetail" 
                    ForeColor="#333333" GridLines="None" CellSpacing="1" Width="100%"
                    EmptyDataText="No data." BorderStyle="Solid" BorderColor="#eff7fa" BorderWidth="1px">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
                    <RowStyle BackColor="#fbfeff" ForeColor="#333333" />
                    <FieldHeaderStyle BackColor="#eff7fa" Font-Bold="True" Width="200px" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <Fields>
                        <asp:BoundField DataField="HFEmpID" HeaderText="HFEmpID" InsertVisible="False" 
                            ReadOnly="True" SortExpression="HFEmpID" Visible="False" />
                        <asp:BoundField DataField="HFPersonnelID" HeaderText="HFPersonnelID" 
                            SortExpression="HFPersonnelID" Visible="False" />
                        <asp:BoundField DataField="HFOccupation" HeaderText="HFOccupation" 
                            SortExpression="HFOccupation" />
                        <asp:BoundField DataField="HFIndBusType" HeaderText="HFIndBusType" 
                            SortExpression="HFIndBusType" />
                        <asp:BoundField DataField="HFEmpBusName" HeaderText="HFEmpBusName" 
                            SortExpression="HFEmpBusName" />
                        <asp:BoundField DataField="HFEmpBusNature" HeaderText="HFEmpBusNature" 
                            SortExpression="HFEmpBusNature" />
                        <asp:BoundField DataField="HFPosition" HeaderText="HFPosition" 
                            SortExpression="HFPosition" />
                        <asp:BoundField DataField="HFServiceYears" HeaderText="HFServiceYears" 
                            SortExpression="HFServiceYears" />
                        <asp:BoundField DataField="HFServiceMonths" HeaderText="HFServiceMonths" 
                            SortExpression="HFServiceMonths" />
                        <asp:BoundField DataField="HFEmpPostCode" HeaderText="HFEmpPostCode" 
                            SortExpression="HFEmpPostCode" />
                        <asp:BoundField DataField="HFEmpBHNo" HeaderText="HFEmpBHNo" 
                            SortExpression="HFEmpBHNo" />
                        <asp:BoundField DataField="HFEmpHomeNo" HeaderText="HFEmpHomeNo" 
                            SortExpression="HFEmpHomeNo" />
                        <asp:BoundField DataField="HFEmpStreetName" HeaderText="HFEmpStreetName" 
                            SortExpression="HFEmpStreetName" />
                        <asp:CheckBoxField DataField="Status" HeaderText="Status" 
                            SortExpression="Status" Visible="False" />
                        <asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" 
                            SortExpression="CreatedDate" Visible="False" />
                        <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" 
                            SortExpression="ModifiedDate" Visible="False" />
                    </Fields>
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#999999" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                </asp:DetailsView>
                <asp:SqlDataSource ID="sqlDsEmploymentDetail" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>" 
                    SelectCommand="sprocHFEmploymentSelectSingleItemView" 
                    SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="HFID" QueryStringField="HFID" Type="Int64" />
                        <asp:QueryStringParameter DefaultValue="" Name="IsMain" 
                            QueryStringField="IsMain" Type="Int16" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</div>
</asp:Content>

